인사연동FAQ

개요

본 문서는 소프트캠프(주)의 DRM 인사연동 진행 과정에서 발생될 수 있는 FQA입니다.

DBSync FAQ

DBSync 설명

SPDTSAgent FAQ

CHECKSYNC 에러

message : insaCheckSyncDataInfo() fail

에러 상세

[FLOG] 23/10/23 05:00:05,867 main - logType : dev.softcamp.swork.spdts.agent.SPDTSAgent, message : ******* STANDARD.OUT.insaCheckSyncDataInfo *******
[FLOG] 23/10/23 05:00:05,868 main - logType : dev.softcamp.swork.spdts.ext.out.standard.method.CustomizedMethod, message : [[ Start check syncdata info ]]
[DEBUG] 23/10/23 05:00:05,868 main - logType : Procedure, message : INSA_CHECKSYNC_DATAINFO
[FLOG] 23/10/23 05:00:05,874 main - logType : dev.softcamp.swork.spdts.ext.out.standard.method.CustomizedMethod, message : insaCheckSyncDataInfo() fail
[FLOG] 23/10/23 05:00:05,875 main - logType : dev.softcamp.swork.spdts.agent.SPDTSAgent, message : run() Exception : java.lang.RuntimeException: execute method error : java.lang.reflect.InvocationTargetException
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at dev.softcamp.swork.spdts.agent.SPDTSAgent.executeMethod(SPDTSAgent.java:88)
	at dev.softcamp.swork.spdts.agent.SPDTSAgent.run(SPDTSAgent.java:75)
	at dev.softcamp.swork.spdts.agent.SPDTSAgent$Application.start(SPDTSAgent.java:459)
	at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:648)
	at org.eclipse.equinox.launcher.Main.basicRun(Main.java:603)
	at org.eclipse.equinox.launcher.Main.run(Main.java:1465)
	at org.eclipse.equinox.launcher.Main.main(Main.java:1438)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.zerog.lax.LAX.launch(Unknown Source)
	at com.zerog.lax.LAX.main(Unknown Source)
Caused by: java.sql.SQLException: Need not run DTS
	at dev.softcamp.swork.spdts.ext.out.standard.method.CustomizedMethod.insaCheckSyncDataInfo(CustomizedMethod.java:114)
	... 26 more

	at dev.softcamp.swork.spdts.agent.SPDTSAgent.executeMethod(SPDTSAgent.java:91)
	at dev.softcamp.swork.spdts.agent.SPDTSAgent.run(SPDTSAgent.java:75)
	at dev.softcamp.swork.spdts.agent.SPDTSAgent$Application.start(SPDTSAgent.java:459)
	at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:648)
	at org.eclipse.equinox.launcher.Main.basicRun(Main.java:603)
	at org.eclipse.equinox.launcher.Main.run(Main.java:1465)
	at org.eclipse.equinox.launcher.Main.main(Main.java:1438)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.zerog.lax.LAX.launch(Unknown Source)
	at com.zerog.lax.LAX.main(Unknown Source)

[FLOG] 23/10/23 05:00:05,876 main - logType : dev.softcamp.swork.spdts.agent.SPDTSAgent, message : SPDTSAgent End ...
[FLOG] 23/10/23 06:00:04,205 main - logType : dev.softcamp.swork.spdts.agent.SPDTSAgent, message : SPDTSAgent Start ...

원인 USER_INFO의 수량이 TEMPUSER_INFO의 수량보다 50%작을때 발생 많은것은 상관이 없으나 적은 경우 인사데이터가 잘못된 것으로 판단하여 종료 처리함. (사용자 삭제로 설정된 경우 재 생성되면 기존의 사용자 암/복호화키가 달라지기에 문제됨.)
조치 방법

ㄱ. 실질적으로 인사DB의 수량이 축소되었는지 확인하여 인사DB가 잘못된 것을 조치 요청한다 ㄴ. 인사DB의 데이터가 축소되었다면 아래 방안 중 하나를 선택하여 예외처리를 진행한다.

A. 인사연동 스크립트 수정 방법(서버상에서 조치 방법) InsaCheckSyncServer

SCI SCISM 관리자 페이지 - SPDTS Agent Configuration 탭으로 이동

SPDTSAgent Script 내용 중 위 이미지와 같이 'script.addMethodName("STANDARD.OUT.insaCheckSyncDataInfo");' 내용을 주석 처리

B. 인사연동 프로시저 수정 방법(DB상에서 조치 방법)

InsaCheckSyncDB

TFTDB - INSA_CHECKSYNC_DATAINFO 프로시저에서 'v_DS_COUNT/2'의 수치 교체

ex) v_DS_COUNT/2 일 경우 50%, v_DS_COUNT/10 일 경우 10%

개요​

DBSync FAQ​

SPDTSAgent FAQ​

개요

DBSync FAQ

SPDTSAgent FAQ